select * from products where pro_name like '%color%ment%' or pro_des like '%color%ment%'union all select * from products where (pro_name like '%color%' or pro_des like '%color%') or(pro_name like '%ment%' or pro_des like '%ment%') and (pro_name not like '%color%ment%' or pro_des not like '%color%ment%')
Multi-color Sweetheart Layered Organza Quinceanera Dresses
Wine Red Taffeta Beaded Dresses for Quince with Pick-ups
Olive Green Floor-length Taffeta Dress for Quinceaneras
Multi-color Organza Quinceanera Gown Dresses with Ruches
Pink Straps Tulle Beaded Floor-length Sweet Sixteen Dresses
Hot Pink Strapless Tulle Sweet Sixteen Dresses with Beading
Dark Purple Ruched Taffeta Sweet 16 Dresses with White Belt
Multi-color Strapless Sweet Sixteen Dresses with Pick-ups
Watermelon Floor-length Taffeta Embroidery Quinceanera Dresses
Fuchsia Taffeta Beaded Quinceanera Gown Dresses with Pick-ups
Floral Embellishment Organza Sweet Sixteen Dress in Spring Green
Off the Shoulder Organza Quinces Dress with Floral Embellishment
Best Hand Made Flowers One Shoulder Sweet 15 Dresses in Green
Simple Organza Strapless Dresses for Quince with Beaded Bowknot
Customize Embroidery Pick-ups Quinceanera Dresses Floor-length
Navy Blue and White Ball Gown Sweet Sixteen Dress with Pick-ups
Colorful Sweetheart Organza Quinceanera Party Dress with Ruffles
Taffeta and Tulle Pick-ups Sweet 15 Dresses with Embroidery 2014
Stylish Strapless Beading Embroidery Quinces Dress with Pick-ups
Beautiful Fuchsia and Aqua Blue Dresses for Quince with Bowknot
Ball Gown Embroidery Sweetheart Quinceanera Dress with Ruffles
White and Gray Organza Embroidery Dress for Sweet 15 Discount
Formal Strapless Beading Dress for Quince in Burgundy and White
Multi-colored Ruffles One Shoulder Sweet 15 Dresses with Beading
Sophisticated Appliques Brown Quinceanera Party Dress in Taffeta
Newest Two-toned Strapless Organza Dress for Quince with Ruffles
Spring Green Ruffles Sweetheart Quinceanera Gowns with Beading
Embroidery Strapless Quinceanera Party Dress in Purple and White
Attractive Olive Green and White Dress for Quince with Embroidery
Latest Rose Pink Ball Gown Appliques Sweet 16 Dress with Ruches